MySQL Database Service Revealed by 2023

Author:2023
Language: eng
Format: epub

ChapTer 4 MySQL DaTaBaSe ServICe

Tip For more information about networking and DB Systems, see the Networking

Setup documentation at https://docs.oracle.com/en-us/iaas/mysql-

database/doc/networking-setup-mysql-db-systems.html.

Let’s look at a couple of these options to complete our tutorial on DB Systems.

We will see how to use a Compute Instance and create a Bastion Session to connect a

MySQL client on our PC to our DB System.

Connecting via a Compute Instance

This mechanism is the easiest to use and it offers the fastest method for experimentation

with or learning about MDS and DB Systems. In this case, we simply create a Compute

Instance and place it in the same compartment as the DB System. We will place it in the

public subnet of the same VCN where the DB System resides.

Tip If you skipped the tutorial in Chapter 2, you may want to go back to the tutorial to see the steps needed to create a Compute Instance.

If you have created a Compute Instance in Chapter 2 and still have it available, you can use it to connect to your DB System provided it is in the same VCN and in the public

subnet. We will summarize the steps in case you need to create a new Compute Instance.

Create a Compute Instance

The steps to create a compute instance are summarized below. Refer to Chapter 2 if you need to revisit the tutorial to learn more about each step in the process. Values used for

entry or selection are shown in parenthesis:

1. Open the cloud console main menu select Compute | Instances

then click Create instance button.

2. Give the instance a name (connection-instance).

3. Verify the correct compartment (oci-tutorial-compartment).

Select the correct compartment from the list.

175

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.